CREATE OR REPLACE PACKAGE SMPK_USER_SESSION IS

  -- Author  : KRISHNA
  -- Created : 5/22/2012 10:10:27 PM
  -- Purpose : 

  PROCEDURE PR_USER_LOGIN(PI_USER_NAME     IN VARCHAR2,
                          PI_USER_PASSWORD IN VARCHAR2,
                          PO_RESULT_SET    OUT SYS_REFCURSOR);

END SMPK_USER_SESSION;
/
CREATE OR REPLACE PACKAGE BODY SMPK_USER_SESSION IS

  PROCEDURE PR_USER_LOGIN(PI_USER_NAME     IN VARCHAR2,
                          PI_USER_PASSWORD IN VARCHAR2,
                          PO_RESULT_SET    OUT SYS_REFCURSOR) IS
  
  BEGIN
  
    OPEN PO_RESULT_SET FOR
      SELECT *
        FROM SMVW_USER A
       WHERE UPPER(A.USER_NAME) = UPPER(PI_USER_NAME)
         AND A.USER_PASSWORD = PI_USER_PASSWORD;
  
  END PR_USER_LOGIN;

BEGIN
  NULL;
END SMPK_USER_SESSION;
/
